Format

The Format section allows you to apply Conditional Formatting or create a Small Multiples view for your chart.

Conditional Formatting

Conditional formatting enables you to apply a style to the chart when the data meets certain criteria that are defined in a condition (best viewed in a table). For example, you can highlight the rows where the total number of orders exceeds 500 units. You can set the condition by selecting the target column, the operator, and the value that defines the condition. You can apply the formatting to the entire row or any column in the table, highlighted by changing the foreground (Text) or background (Cell), or border color.

To add a condition, expand the Conditional Formatting section and select + Add Condition. A new Condition section is added with an auto-assigned label Condition n, where n is a sequentially generated number. Select the section to expand it. You can apply formatting elements as needed.

• To change the foreground color, use the color picker next to Text Color. This has not been changed in the example.
• To change the background color, use the color picker next to Cell Color. This has been set to lime green in the example.
• You can highlight your selected area by outlining its border or have the highlight color fill the area from the Style selector. The Filled style has been selected in the example.
• You can apply a custom Label to the condition to identify it among multiple conditions. The example condition is High Orders.
• The criteria is Sum of Orders > 500.
  • Column has been set to quantityOrdered (SUM)
  • Operator has been set to Greater than
  • Value has been set to 500.
• This style has been applied to the row (Apply this style to the Entire Row). You can also select one of the columns used in the chart.

As you make changes, you can see the changes applied to the chart on the canvas. You can add any number of conditional formats to a chart. You can switch chart types and retain the set condition, as long as it is supported by the selected chart.

Conditions can be deleted by selecting the Remove link in each section.

Applies to: Bar, Line, Symbol, Table, Expandable Table, Crosstab, Multi-Series Bar, Multi-Series Line, Multi-Series Symbol, Combo, Dot Map, Bubble Map, Funnel, and Pie Charts

Small Multiples

The Small Multiples feature produces one chart for each distinct value of a selected column, allowing you to show multiple charts of the same Value and Category compared through the third column of your choice, all on the same canvas.

To produce small multiples of any visualization:

1. Create a chart that supports the feature and configure it to your liking.
2. Expand the Small Multiples section and drag and drop the column to use to create multiples onto the shelf with the guide text Drop column here. When a column is added to the shelf, the section expands to reveal other options.

• Multiple Labels controls the showing and hiding of each value of the selected multiples column as a label in each generated panel. Multiple labels are shown by default.
• Borders turns borders around each panel of multiples off or on. Borders are shown by default.
• Max Panels controls the number of “multiples” panels shown. The default value is 50.

The following displays the number of vintage cars and motorcycles in stock for each quarter in the year 2019.

To create this chart:

1. Create a simple Bar Chart by dropping productLine onto the Category shelf and quantityInStock onto the Values shelf.
2. Filter the chart to contain Vintage Cars and Motorcycles product lines for 2019 data.
3. Set color, orientation, and range of the Y-axis.
4. Drag and drop orderDate onto the Multiples column. The date is automatically grouped by month and year. The example uses quarter and year.

If the column used in Small Multiples is a date column, you can select Date Group from the options (three-dot) menu. Use this option to select how to group the dates in the column.

Applies to: Bar, Line, Symbol, Min/Max, Multi-Series Bar, Multi-Series Line, Multi-Series Symbol,and Combo Charts.